GeneralLedgerReleaseBatchDetail 
EntityType  Independent 
Logical Entity Name  GeneralLedgerReleaseBatchDetail 
Default Table Name  SaGLRelease 
Logical Only  NO 
Definition 
 
Note 
 

GeneralLedgerReleaseBatchDetail Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
GeneralLedgerReleaseBatchDetailId(PK)    INTEGER  NO 
 
StudentAccountTransactionId(FK)    INTEGER  YES 
 
StudentRevenueDetailId(FK)    INTEGER  YES 
 
BatchNumber    CHAR(8)  NO 
 
TransactionDate    DATETIME  YES 
 
AccountNumber    NVARCHAR(100)  NO 
 
DebitAmount    MONEY(19, 4)  NO 
 
CreditAmount    MONEY(19, 4)  NO 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
LastModifiedUserId    INTEGER  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
TransactionDescription    VARCHAR(50)  YES 
 
GreatPlainsAccountIndex    INTEGER  NO 
 
StudentId(FK)    INTEGER  YES 
 
Type    CHAR(3)  YES 
 
MiscellaneousCashId(FK)    INTEGER  YES 
 
StudentSubsidiaryAccountTransactionId(FK)    INTEGER  YES 
 
GL_Entry    VARCHAR(25)  YES 
 
Period    SMALLINT  YES 
 
FiscalYear    VARCHAR(5)  YES 
 
IsReleasedToVantage    BIT  NO 
 
JournalEntryId(FK)    INTEGER  YES 
 
BankDepositId(FK)    INTEGER  YES 
 
CostAccount    CHAR(30)  YES 
 
PayeeName    NVARCHAR(150)  YES 
 
PayeeAddress    NVARCHAR(300)  YES 
 
BankDepositId(FK)    INTEGER  YES 
 
JournalEntryId(FK)    INTEGER  YES 
 

GeneralLedgerReleaseBatchDetail Keys 
Key Name  Key Type  Keys 
SaGLRelease_BatchNo_N_N_IDX  Inversion Entry  BatchNumber 
SaGlRelease_SaStudSubsidiaryTransID_SaGlReleaseID_U_N_IDX  Alternate Key  StudentSubsidiaryAccountTransactionId, GeneralLedgerReleaseBatchDetailId 
SaGLRelease_SaGLReleaseID_U_C_IDX  PrimaryKey  GeneralLedgerReleaseBatchDetailId 

GeneralLedgerReleaseBatchDetail Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
BankDeposit  Non-Identifying  Zero or One to Zero or More        BankDepositId  NO 
BankDeposit  Non-Identifying  Zero or One to Zero or More        BankDepositId  NO 
JournalEntry  Non-Identifying  Zero or One to Zero or More        JournalEntryId  NO 
StudentSubsidiaryAccountTransaction  Non-Identifying  Zero or One to Zero or More        StudentSubsidiaryAccountTransactionId  NO 
JournalEntry  Non-Identifying  Zero or One to Zero or More        JournalEntryId  NO 
MiscellaneousCash  Non-Identifying  Zero or One to Zero or More        MiscellaneousCashId  NO 
Student  Non-Identifying  Zero or One to Zero or More        StudentId  NO 
StudentAccountTransaction  Non-Identifying  Zero or One to Zero or More        StudentAccountTransactionId  NO 
StudentRevenueDetail  Non-Identifying  Zero or One to Zero or More        StudentRevenueDetailId  NO 
StudentSubsidiaryAccountTransaction  Non-Identifying  Zero or One to Zero or More        StudentSubsidiaryAccountTransactionId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

GeneralLedgerReleaseBatchDetail Check Constraints 
Check Constraint Name  CheckConstraint